CREATE TABLE [dbo].[DnnProduct_Links]
(
[ItemID] [int] NOT NULL IDENTITY(0, 1),
[ModuleID] [int] NOT NULL,
[CreatedDate] [datetime] NULL,
[Title] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Url] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ViewOrder] [int] NULL,
[Description] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedByUser] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_Links] ADD CONSTRAINT [PK__DnnProduct_Links__113584D1] PRIMARY KEY NONCLUSTERED  ([ItemID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DnnProduct_Links] ON [dbo].[DnnProduct_Links] ([ModuleID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DnnProduct_Links] WITH NOCHECK ADD CONSTRAINT [FK__DnnProduc__Modul__1229A90A] FOREIGN KEY ([ModuleID]) REFERENCES [dbo].[DnnProduct_Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION
GO
